SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002078s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461212 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461212 [ RunTime:0.004185s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (328484,154509,791970,979576,26158,351054,406586,890372,293520,312945,739639,370955,759475,161180,1035499,513695,327168,171122,616088,787967,279034,766148,429222,878839,696982,464675,120382,136740,687606,933702,144479,864524,402101,169609,362867,1043304,1026411,785744,24271,686405,505283,516325,733117,1040447,784677,939039,759201,651534,771572,206878,290538,698369,246891,805773,840368,343137,421347,265370,43495,292232) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]