SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198452 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198452 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511133,1019420,97166,600666,38125,601183,196630,759944,112394,329525,1024614,795292,189017,627093,83014,625361,710301,744700,261254,697372,707044,438687,199507,422,141208,878382,449463,355948,580177,677410,824308,640923,809334,172111,601490,835762,576036,343174,277989,459913,915210,824664,825551,468985,767910,644094,1033956,18621,710959,777452,627729,254166,834693,874429,380887,75828,671380,109809,756633,726078) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198452 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198452 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]