SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001413s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405364 LIMIT 1 [ RunTime:0.000772s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405364 [ RunTime:0.003538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (733611,510466,432005,381094,617321,481066,941945,836485,466678,343152,593173,456909,56446,305481,740470,753310,262293,244390,533230,80299,769679,836862,1000507,874441,314115,1009012,914562,950904,543779,385954,186134,1001741,634471,842826,26545,38090,978973,659684,1005958,280018,753449,399184,643336,35374,923993,270657,557308,686099,9262,665272,234258,561197,386689,321621,196315,643695,643843,636610,470382,401898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405364 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405364 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]