SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002640s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549731 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549731 [ RunTime:0.001730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (920627,690311,39708,176368,649623,341408,367564,478149,749404,299510,129549,389159,460996,721923,401314,977438,437056,50104,362230,90305,694886,890871,220285,828057,460602,191992,69770,449547,616029,220698,656491,161189,816961,715409,653642,243262,8751,329146,245119,317922,22596,719877,251408,944037,761102,201308,351457,375988,892439,191378,977938,978894,826427,380075,254230,303283,481638,654227,567372,617768) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549731 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549731 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]