SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522008 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522008 [ RunTime:0.001636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (331019,373375,898362,394446,966531,396481,404593,537832,748176,299907,118436,394516,181959,209662,317458,561111,777006,390285,142068,317887,934614,300382,25024,130204,556956,645776,538478,809398,70064,405104,729851,871842,66071,114130,14006,661173,978775,416240,773080,51673,866596,877706,698677,1008835,968999,419203,741187,225788,69399,869838,932197,659018,621637,596452,8543,909236,84091,430135,233554,433994) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]