SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 523842 LIMIT 1 [ RunTime:0.002001s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 523842 [ RunTime:0.006031s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (685928,645147,120168,76043,462682,908494,173359,658037,281059,1018525,760837,436482,466646,211504,896235,307041,65986,119983,272421,444630,541882,406313,1005474,46553,995948,253464,764589,657222,354497,210794,594254,948867,582251,760563,201522,296613,443005,968882,99348,688266,716716,464927,1001207,20067,169041,262519,75074,913427,1033393,399811,752651,874039,97751,423617,124871,865479,706709,1034698,414346,33051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 523842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 523842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]