SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345624 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345624 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362596,54670,155379,264211,320096,233833,530718,501138,160719,104882,314595,406827,784032,327275,973396,763890,803136,165375,944309,743763,4615,858163,256976,299006,326843,764175,302910,976412,393513,192520,471748,776931,248063,435523,584712,889977,516723,455402,221869,111279,754940,819167,803122,123052,85452,211374,446638,833253,620430,257705,250031,193749,820641,807558,311466,454068,294554,657282,857801,876163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345624 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345624 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]