SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 654080 LIMIT 1 [ RunTime:0.000479s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 654080 [ RunTime:0.001878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (797376,988708,723521,627725,843438,504370,237216,176479,678895,286506,65018,18799,380562,447424,990792,693257,830960,449509,804099,960561,880107,314278,21490,254025,626349,243468,642561,522747,253218,609134,675589,584862,959448,888688,767540,817641,82055,774306,527408,96113,772658,407214,251596,930342,42321,677762,1010234,26329,684823,435637,909290,583388,258744,1001908,120045,250542,699189,113687,409006,341709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 654080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000847s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 654080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]