SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342968 LIMIT 1 [ RunTime:0.001498s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342968 [ RunTime:0.002000s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (179200,950910,1001039,649149,616922,886483,981674,578954,179147,459882,310564,673399,750611,148965,527356,523182,160472,399462,854519,694134,449747,38592,750816,826310,479104,230642,884105,1004006,647222,642647,106604,927105,431887,329170,944182,726250,50488,928672,804248,429375,438408,324421,676591,951326,980866,703750,952007,954388,335348,1036397,343196,207973,209390,702416,103679,929158,259295,454783,474421,919536) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001138s ]