SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 69201 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 69201 [ RunTime:0.001738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (396028,774438,993546,452958,448771,206573,225481,387194,262800,180977,437866,832080,94844,52336,329395,414710,851878,649460,517890,933286,146652,167183,129583,894054,873352,177104,733953,398922,607711,241884,651264,962490,286278,673978,132791,480191,598058,987143,393189,505519,386354,418654,183759,855886,357805,211508,565404,293695,295745,764412,720888,331644,404984,792800,456441,918836,60235,637355,42528,670979) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 69201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 69201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000710s ]