SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002830s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335841 LIMIT 1 [ RunTime:0.001000s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335841 [ RunTime:0.002671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (130546,252273,796646,633079,474403,807538,428783,215354,254046,711474,962984,937530,930434,851923,233084,29644,676651,526181,555671,277188,383349,949651,650813,1015300,135315,18344,794756,77935,409930,919917,199367,590986,179049,587011,794099,114738,481874,482964,411715,1016762,219687,520138,960336,844056,367397,658493,558109,973162,462777,779697,724169,781394,260275,917395,541437,327820,454461,995992,819837,998475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000681s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003020s ]