SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431032 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431032 [ RunTime:0.003716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (490313,121040,400820,144312,991971,114551,394246,172079,437475,22569,562064,80981,290076,756253,773473,189586,104985,656358,1016978,201522,570557,65108,642461,949673,288383,904719,936810,771070,293998,462601,542888,873509,126925,495210,392849,748153,191967,221983,1004151,325696,730099,821070,340572,181574,61719,43509,117496,247992,583300,1026563,73082,741665,514728,111658,145988,1004820,294302,213727,34222,447823) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431032 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000609s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431032 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]