SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011812 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011812 [ RunTime:0.002248s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (925568,898734,74227,916224,229518,145060,824822,195760,221154,224684,666640,610563,282719,1041807,708905,652945,483001,356130,581109,106733,495975,693881,896960,814437,147890,515556,838291,64388,7727,38795,619697,888521,348838,157059,646925,329247,70029,387931,752531,763204,100580,842435,875295,911371,2167,1045554,159942,372085,853162,559869,46433,770810,331566,742968,385709,108900,141772,623078,1047876,240944) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]