SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 47534 LIMIT 1 [ RunTime:0.004406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 47534 [ RunTime:0.004895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (256998,842140,565384,249876,82305,1000615,230787,29131,95794,944106,890417,532745,433380,709435,1018798,984089,847397,332575,834131,181002,301235,188819,127603,889573,283584,73128,518969,582146,986668,425788,480490,225095,922856,497577,669448,301395,507582,79680,800923,822566,395647,151703,425747,264941,134752,858261,163354,491819,1003277,15066,24179,329618,185808,107988,477471,620322,875122,705563,823853,647663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 47534 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 47534 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000711s ]