SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200513 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200513 [ RunTime:0.001571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (125506,307086,809235,1000499,151937,721739,331946,260356,219258,556074,371772,409612,530288,364691,462197,740946,939323,870097,405438,796364,1048709,377195,960402,85602,448278,610504,338846,352023,847244,805154,912693,894441,1033803,902578,545482,978636,323244,849775,709920,372027,543357,404509,555221,183778,150832,687720,1031996,490135,870955,919653,596458,832473,451094,968021,537288,548675,752921,694192,752813,822704) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]