SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020334 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020334 [ RunTime:0.001904s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (573291,583297,891784,647951,856229,329461,871341,650143,398120,155096,899315,233948,549906,658924,132617,915812,1046179,456515,34136,236812,186221,45945,518309,104228,708501,906709,703068,646489,158434,1038660,815805,96843,199476,273157,64058,609209,937326,282853,153016,929690,126004,861130,164725,788941,901513,516687,603325,305031,961001,473988,1044229,238296,215429,596226,404288,1031536,111004,413889,17656,700347) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020334 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020334 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002495s ]