SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1007884 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1007884 [ RunTime:0.002412s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (934705,948738,364717,131887,644245,197246,691472,935551,201865,14403,648468,499639,719834,1047644,588597,563099,218653,690164,1028596,647626,858316,827154,404105,159132,328073,498258,611676,561683,211731,108742,424950,603424,73800,366675,210176,543583,336803,540026,82844,248755,9269,28624,901004,373171,523136,296468,945063,182759,445280,748944,363889,408405,490935,241219,879237,404058,1013577,952117,625703,723815) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1007884 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1007884 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001706s ]