SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001437s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034270 LIMIT 1 [ RunTime:0.001540s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034270 [ RunTime:0.005702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (543027,373320,661747,539210,575890,507498,437556,543342,808446,853155,574563,151962,654116,236328,906247,77852,1040317,563496,252637,43274,96679,277456,539020,820186,122248,90918,895081,534333,357629,287790,437737,256083,481408,705766,235443,439908,1024549,344054,982885,691413,380803,928803,247235,855936,99076,254741,279066,635755,819470,268061,770031,48366,103442,453737,924744,204440,270012,305399,297028,256153) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034270 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034270 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000963s ]