SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002077s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 950940 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 950940 [ RunTime:0.001863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (381676,148836,121410,494070,755716,916427,9436,328500,575578,685491,993387,156870,794311,609059,687705,549357,1001658,334162,935306,262237,467628,740699,481318,787671,1012578,70690,818862,1046232,720086,924752,451207,764103,5739,982794,45954,26856,827572,826891,160191,25534,364074,1031294,15763,1027798,297067,1010014,46868,296338,484488,144965,289005,183121,717720,210371,349517,296768,1046134,964813,509582,34892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 950940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 950940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000790s ]