SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406881 LIMIT 1 [ RunTime:0.000499s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406881 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (994841,687736,684205,13676,550680,627055,275017,253900,46041,715616,966654,174388,246193,433945,226844,460017,87591,91222,1016312,161238,631771,737280,612907,417054,853934,75853,338335,755744,381601,150462,417920,29984,570691,950101,238343,64426,260881,888830,763719,644886,677723,262094,788553,815307,573301,292042,7990,125335,438552,911021,561173,821976,177218,601017,363187,620502,792963,318376,300069,727105) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001336s ]