SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415566 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415566 [ RunTime:0.001953s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124085,747690,102681,235081,4761,929269,600481,35369,231839,265075,44671,346678,730711,731105,361564,328012,1039952,93771,799122,756514,447670,536670,379900,918895,435909,1017923,90591,984965,740179,119590,629432,349071,1001679,254235,448905,1035855,31597,420527,730637,389435,87113,732841,199158,782852,307579,33236,16832,177261,939753,501230,119574,978687,468078,648424,319648,511263,91962,1038426,852610,1007429) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415566 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415566 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]