SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455534 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455534 [ RunTime:0.001476s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (253339,382846,1020107,976729,1029739,884252,860490,86756,52142,248070,43782,664430,742600,430334,398304,52797,866491,986269,167316,129236,940447,456125,56126,886730,474957,608112,627847,442705,592573,839803,871310,890840,26962,603002,230052,681713,1014638,294003,744968,843861,549743,154883,182858,296522,653115,544767,679957,1047230,109656,901797,499372,741734,939869,532480,433089,620545,426048,882031,758193,424474) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455534 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455534 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]