SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45860 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45860 [ RunTime:0.002336s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1045443,537859,947008,765618,455898,659768,696407,597109,856818,94491,520296,471981,866819,674771,807010,12193,293656,490446,65737,904895,366717,870546,424621,696985,805476,949378,198123,883830,573581,494083,39093,12883,231035,1865,337869,1003003,685326,467335,457472,56720,31046,959438,919688,432047,68085,675545,383647,990376,968747,457172,957240,387727,884322,61377,531419,237402,822482,52651,447001,603955) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]