SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205754 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205754 [ RunTime:0.001874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (633854,47633,437309,772620,310220,946182,410625,1002031,912299,483321,353520,747081,851845,508276,382546,252428,870132,531612,50182,558441,883226,479439,507912,1010076,173393,160249,1024191,614590,413888,691685,515969,99539,235272,940929,942313,80293,291940,665270,817783,650481,1019840,902115,28437,342019,727703,849797,405793,1007018,243340,285486,812255,580363,270718,881422,206059,1005084,334333,580104,800301,94270) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205754 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205754 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]