SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040348 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040348 [ RunTime:0.001552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (989770,247882,815328,199963,106681,256172,280932,964901,889132,499579,700063,999152,651380,141166,464680,254765,620262,731561,435119,650846,286134,895040,691240,469265,712285,1030445,954164,31806,357296,369685,890396,97366,36150,66470,695792,1825,621004,97177,478921,764295,708138,38320,424721,652419,68582,403148,88031,963371,29703,72661,265386,760192,735905,133506,2985,805501,388932,728830,235845,438562) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000930s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040348 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040348 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]