SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475335 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475335 [ RunTime:0.001684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (979436,327650,51752,407540,202004,467839,743589,345392,546408,1045303,154998,131140,486104,651556,810312,157930,444623,679743,645788,613436,147431,254528,261633,504073,99108,96752,221686,922014,216737,833807,519639,826880,576491,805265,232476,463280,709545,229315,78036,305874,282257,817977,783153,109854,583526,776393,188890,298320,730244,263602,207497,623550,339918,711132,776414,645546,262964,749871,95199,912277) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475335 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475335 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]