SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431706 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431706 [ RunTime:0.001617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (279766,225207,832405,191237,1024753,654798,590386,65170,76713,698463,378708,447813,257101,386469,673374,702498,769398,147703,510693,631980,971037,116546,547734,16939,277191,761749,775900,286637,159020,369353,449239,360786,183657,955189,46368,266040,428705,1013234,644715,445647,733430,486810,500879,301833,36477,176397,483816,254344,505079,1009464,283533,159303,137509,629123,854457,975383,372735,558131,950423,534465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431706 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431706 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]