SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 148743 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 148743 [ RunTime:0.003313s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (537043,728800,246618,853538,663798,853900,332266,175439,110919,894797,349837,887323,1045558,1042318,441120,442687,174801,434183,681192,85812,487517,433874,352409,571200,817496,125788,75306,932781,197192,316716,526883,940945,232665,370643,917280,427726,673423,939709,71101,315710,825395,496523,560648,689709,458623,937091,879659,291554,739510,1044724,415289,252537,591997,68834,341831,849137,987119,486799,1012774,365162) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 148743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 148743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]