SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452611 LIMIT 1 [ RunTime:0.001011s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452611 [ RunTime:0.002249s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (241277,711724,46707,603212,330924,383097,916261,760463,157705,951433,412662,209157,846148,794754,546001,830324,140489,123037,734231,474849,346956,564640,506496,644387,656281,95914,309094,1010052,1010181,843521,286463,935893,509988,358120,322199,121188,533357,412673,99452,771544,190474,292018,804479,373743,32438,239835,955913,501594,154848,204962,86635,146917,952395,24326,997315,485190,575928,254369,46821,794706) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.024192s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002741s ]