SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453284 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453284 [ RunTime:0.001856s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (584133,787195,215370,330134,708878,1013438,115668,837751,653831,73545,629748,640173,12481,1041915,114381,491630,960133,911753,202928,656712,452829,872766,564595,673692,223290,42663,299454,699787,227950,898232,747953,634372,616316,600713,523694,444691,312068,643015,987158,622179,1024155,340613,891737,818136,847839,1040947,870184,193568,271497,102762,992272,693604,975145,245335,330594,77878,970961,214943,401344,660928) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453284 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453284 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]