SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494128 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494128 [ RunTime:0.002852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400902,539872,948664,447513,230278,366563,413656,821950,659650,553544,293005,17973,985229,628742,126095,475024,826318,720640,957817,288622,542275,350849,378839,191401,253004,980889,76350,140082,260389,764778,321207,861635,60161,411702,191838,1019506,426303,529248,897981,526560,74543,949341,1003300,533882,415799,75592,644158,108099,1043886,119417,540721,552069,127059,249788,553493,422721,543871,250109,186945,747673) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494128 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494128 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]