SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003587s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40956 LIMIT 1 [ RunTime:0.004000s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40956 [ RunTime:0.003543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (619645,160905,1006762,1016450,1028406,978584,736859,690407,593259,1018264,202601,48717,420029,422729,483777,234561,588176,714377,897105,129903,839933,837034,201355,82366,184948,436280,34751,119915,428189,601184,878533,316921,414992,328379,772056,681452,595441,747985,114345,94145,650743,266128,125595,283962,645726,745587,647928,779548,541542,320985,28102,1046345,300186,717135,698708,74829,1022260,561395,620698,925222) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40956 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40956 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001130s ]