SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 983957 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 983957 [ RunTime:0.003891s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311287,1042515,606219,431965,79708,480335,413166,100672,731589,63601,266748,91670,245731,48022,1042053,738139,949027,955825,639472,482049,394414,955002,385565,477131,1042738,492549,932134,703507,506578,344131,788350,438912,353010,657307,575798,272641,407178,428434,512073,110527,341451,460054,1046213,1044740,42393,214304,411886,447518,54459,376168,291460,101431,288746,409348,302822,52314,982167,124095,477125,600432) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001535s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 983957 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000853s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 983957 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001243s ]