SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301219 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301219 [ RunTime:0.002063s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368498,461259,372881,525948,368505,209960,749606,777781,411803,68970,1014292,96624,825461,347507,245194,397072,575298,182253,23812,815240,670300,154802,233633,991464,22926,988011,23288,66387,521970,1016824,434838,282167,445420,328090,373264,8648,576237,199943,890264,83678,334268,525430,682277,962879,709980,732310,19470,303360,143101,295857,767754,1003723,870230,767144,639056,111325,122298,374260,330741,808214) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301219 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301219 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]