SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591409 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591409 [ RunTime:0.001720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (598075,996301,394052,872280,342521,247710,1039554,341275,86736,896827,57975,180832,359346,551144,796403,682074,584471,283757,409097,639051,224674,713078,520378,942304,875146,634952,267065,105141,122474,835379,737544,940886,238057,387143,107161,1015766,957810,893501,178008,983536,301475,138249,431162,879880,996139,964875,59137,989580,581350,364712,120828,672776,116613,333160,369554,1038512,920266,61962,78225,357911) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001643s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]