SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405980 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405980 [ RunTime:0.002633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252869,739245,730608,629531,718031,73221,706178,152231,896991,645227,623239,719084,914423,867643,409821,568880,899348,428596,780924,594550,616405,880649,273003,748810,545891,1039173,388571,306455,77512,572530,802586,140519,909444,377702,992098,264489,478356,283890,1030266,986017,104446,736319,292862,43465,405650,123110,798792,548274,347527,545593,395285,740046,1003042,310470,398544,670308,840191,610410,49482,400985) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000697s ]