SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018344 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018344 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508884,272527,736585,417464,376153,356786,59726,663354,265015,442341,152719,76635,42034,119738,112766,758649,49882,763392,64140,778078,948106,994006,569233,238177,826525,132020,844445,218467,46159,688582,371886,272619,937112,90147,486073,561030,334976,76850,833326,340638,695220,871494,1023233,468196,902026,465218,333710,627156,400776,578620,68924,9964,21241,197436,187209,166138,99885,795327,474135,471319) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018344 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018344 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]