SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 692104 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 692104 [ RunTime:0.001888s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (569065,877901,221066,216148,786338,1019053,897564,696970,392195,787030,477635,1043663,793599,866903,812279,69453,252767,756170,257050,586805,758119,510518,626879,682420,277865,917830,558241,527876,917381,367944,862513,619446,223011,891716,256955,460140,75918,82887,772952,90362,984195,659969,459052,656218,501604,618099,1042362,979732,622108,336592,671462,782708,144305,5885,309835,104383,869100,539974,726305,159647) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 692104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 692104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]