SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503604 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503604 [ RunTime:0.001667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (37280,140947,88294,377193,113014,574931,355630,648615,159625,292798,558490,264116,667063,69629,877391,715129,993644,362740,182558,714183,525772,322888,253190,349650,786077,645615,797134,203523,815000,528608,276037,289827,967145,154987,841187,27725,612805,778772,929743,989583,724071,312074,967279,165082,264878,934380,580856,17153,180622,794379,935135,790890,619627,591251,1004346,1020071,872405,92889,390430,144340) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503604 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503604 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001051s ]