SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541473 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541473 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530906,776590,991349,761067,942511,977996,862190,811477,473610,283928,984534,260236,23250,827707,535155,924218,178691,1026998,18276,39910,706952,146160,334015,75430,199232,950481,920583,5184,554846,37562,309617,291115,165011,241647,703624,119661,583620,691343,939146,571393,1022230,56919,112650,245386,466960,535864,791916,724513,493473,241184,538589,314709,965264,157255,423219,329068,28178,161930,752820,229739) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]