SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001605s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409713 LIMIT 1 [ RunTime:0.000490s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409713 [ RunTime:0.003061s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469644,422098,1011031,396487,602145,359316,93149,758949,632865,389964,728743,177004,957933,600370,1029398,105394,977973,22603,302875,345483,1045923,262984,633763,405872,1016080,507654,721921,379167,779600,619133,133803,40312,427494,144679,193306,536645,40491,548112,448201,526564,69716,948118,674911,179537,407947,255760,423001,971688,990008,291960,394949,334815,1016508,357980,142606,57330,429713,727586,974879,467055) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000628s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]