SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001642s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381412 LIMIT 1 [ RunTime:0.000503s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381412 [ RunTime:0.002959s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014464,429987,863915,1002644,185861,12016,673625,693411,244878,205232,709217,41436,470779,794525,665444,352791,151734,120433,411747,478197,804462,374981,56300,108115,494985,686582,453564,938555,871877,451986,130704,650223,156458,375134,974233,230393,98425,890665,709169,785689,806684,771698,525477,209800,1046937,767129,332,120024,145054,256696,363502,896882,189515,911447,779625,965796,494765,1041790,2447,992358) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]