SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 352476 LIMIT 1 [ RunTime:0.000517s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 352476 [ RunTime:0.002136s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011239,805331,668178,998792,514145,84589,794218,629597,158822,543251,38422,76935,502530,268473,220147,907235,515366,366527,247334,174963,1037799,910162,784693,688245,89407,1006020,786420,438320,315899,840723,908070,207137,479824,351646,116513,552190,587742,657836,768032,295153,242936,194604,441020,584927,35434,288138,748163,887677,679830,1012780,876442,835116,687340,298407,115963,11534,803730,488533,562589,441146) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 352476 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 352476 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]