SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405597 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405597 [ RunTime:0.001529s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (718457,628099,66305,858450,10161,6016,682184,409844,363959,595506,77627,247955,812158,242241,529060,610032,502159,329428,249342,929564,376565,424561,422530,422584,332581,983509,941878,848130,441981,1028317,764332,148057,283796,135718,551003,865566,745312,476013,362179,335060,76584,380219,381145,679100,265757,423421,966766,515056,22881,777082,120352,819895,57516,980899,670555,114462,632970,328091,482545,603574) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405597 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405597 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000705s ]