SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 800190 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 800190 [ RunTime:0.002082s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022004,381618,136946,28225,246884,165713,131726,632240,529240,255630,78351,317973,268789,688718,803886,512807,469409,150033,364891,205924,92820,509416,759753,269384,836550,961187,322028,610113,432575,40984,537737,194454,195417,460381,775858,808426,21601,895170,531159,928830,327750,400153,651201,353038,914927,789010,212157,668398,694218,433583,297624,4541,83300,247427,863313,676512,136253,202619,974718,143958) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 800190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 800190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]