SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 304300 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 304300 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (372221,225789,471644,240576,134111,838926,886598,670726,890399,720871,925158,630604,54188,651310,347008,224989,915722,254181,397504,947368,158524,126995,1006968,67786,282351,1024296,574441,860280,768490,433879,789063,990933,880675,483331,80374,9947,564800,767933,798712,575639,942867,944740,869827,884400,259274,716440,1028729,819818,924745,93375,1002957,408834,1022187,733136,44254,197128,287319,23707,239284,576056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 304300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 304300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]