SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809404 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809404 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (245574,947596,173775,231478,676579,567202,421927,393347,954902,547763,304775,976178,483759,1004592,897632,544777,29991,895070,167722,337369,253104,846214,704739,399236,304122,207328,688523,180088,117375,996143,628896,978028,607011,903416,135802,153578,900444,463267,2055,207204,462766,140599,423053,1047789,16038,835754,743283,593606,526696,849917,796730,217423,553673,729515,470134,1014866,38074,901068,224679,1034395) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001681s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]