SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 56463 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 56463 [ RunTime:0.001853s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (74178,118406,241820,437609,902918,506111,1045428,19941,839278,415452,261503,210808,400630,677617,949746,817289,592873,1045180,572775,470408,98398,589935,126875,69682,1037487,480587,860649,881901,400981,605162,306334,124166,341381,376633,605572,788242,500671,186129,384242,282436,24239,106646,740301,491713,409132,325538,671542,1047501,675833,279449,1012124,1022412,804131,327151,47483,684551,443532,352750,466175,754927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 56463 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 56463 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]