SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412543 LIMIT 1 [ RunTime:0.000547s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412543 [ RunTime:0.002738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (73194,8521,989469,717760,164206,121901,202345,927110,579054,686869,998087,944110,432251,855434,395092,967684,908801,1019667,744107,793350,837504,932539,143783,699995,238664,725830,324216,515843,309861,446452,654368,949373,32173,790141,513303,791513,718672,583195,817325,787493,559325,34070,792317,557544,1027183,172637,646017,172504,298387,417423,114695,390580,284801,926046,938181,448203,216997,779176,970807,514758) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]