SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004981s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 390806 LIMIT 1 [ RunTime:0.003625s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 390806 [ RunTime:0.002646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (62992,1007701,367019,292341,261296,486435,416751,909699,538551,960023,948050,389685,503807,852908,85532,1001738,889249,549893,440001,838360,109064,821612,205523,135242,308872,47105,753400,31096,178829,203524,585362,22878,894294,22838,986664,505175,1024013,953336,10223,972048,26350,625740,738559,848949,360431,962644,726955,443199,1022227,82047,437826,555305,659401,847639,585955,799076,472708,650225,728224,1048555) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 390806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 390806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001609s ]