SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480040 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480040 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (381410,327794,792725,369781,1024842,905307,992711,956316,395168,312159,716037,218635,607296,825116,721121,324953,715139,406979,791822,699176,1038095,585919,634759,366393,1046604,50106,487109,216564,518505,552752,302254,804007,432362,981635,842981,3613,92698,227535,571080,737736,83322,954678,611659,854808,564250,42691,294734,17709,531190,137118,146806,9235,158668,552993,719992,145473,983344,82332,804797,802862) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]