SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423145 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423145 [ RunTime:0.002065s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107337,158216,131162,151507,163423,912712,81326,666723,110913,173735,320129,1009617,1048495,969479,290362,491375,611460,1039135,607231,1042874,410734,504985,291346,411753,36587,716967,101723,289576,851217,604531,516630,1037391,425289,162075,953862,338505,332958,227300,938054,982306,531017,1010207,400115,2248,1012049,621943,318089,881538,661867,159123,269800,731877,180765,766667,485736,872824,160247,365326,225213,258210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423145 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423145 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]