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` = 40739 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40739 [ RunTime:0.001660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (914510,444506,346988,497341,616915,909349,980469,361732,724282,921745,931079,721371,377009,620030,629329,410079,596160,286681,1006146,135213,444984,341419,651125,610072,1009814,142840,1047608,920986,156021,201921,612572,723138,184944,607334,256673,626555,853366,149273,171341,35792,342113,292273,567330,514588,683142,50980,10205,1015013,927776,223778,786238,176853,27897,465460,561056,549603,351455,11320,108293,129751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40739 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40739 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]