SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393051 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393051 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020415,425997,168405,683081,54502,847008,226083,408293,239228,359706,272608,523157,184116,131728,783927,764117,229940,332862,918086,437225,267042,244878,392197,201053,739857,210361,1043219,596399,948994,1003513,954292,91373,710042,37605,622182,882527,373723,158337,21775,809163,741549,649527,448561,624905,987634,244470,353792,762788,793441,294226,829385,229340,1021565,248057,388317,830966,1035993,592223,788120,37403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]