SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 244710 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 244710 [ RunTime:0.002575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (42412,470354,363169,680283,416481,233996,312715,174920,76497,872493,321645,446692,218875,19880,1033958,38826,629974,205793,651017,371082,780515,11132,897165,732559,511790,362999,601692,603531,981042,368912,829660,362124,934439,150170,998467,223794,472628,91619,664626,950341,942223,702928,531583,238875,758612,583768,176452,1019100,351071,986076,753240,447537,919180,210604,580024,267584,105094,131668,173471,887863) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 244710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 244710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]