SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 344181 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 344181 [ RunTime:0.001983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (476896,335860,362326,621026,265813,850091,654630,974253,348999,625968,218530,837437,1001139,68941,428325,496371,772836,920290,1021340,649658,534695,882434,651699,799116,374269,60047,114510,165770,52467,998855,639400,392264,689137,397852,158449,265203,520783,54118,760375,263002,669310,292768,1009801,596482,540768,409824,380447,779999,1022618,471951,425858,931647,197949,672050,478535,973973,325032,245896,320374,445130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 344181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 344181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]