SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409548 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409548 [ RunTime:0.005110s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (663480,726975,909846,773081,925962,75109,935074,97591,808672,292758,655987,490877,851845,972519,670374,527900,493305,98199,558682,522622,254716,65710,154055,490810,503804,103016,284286,819662,1041386,310199,831148,379025,27339,183583,148278,390833,328176,4072,784796,289604,350877,86808,674366,499460,418048,400849,732787,540956,1003229,427335,337594,897543,759176,957137,953216,869426,165225,1029251,191044,1029338) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409548 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409548 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]