SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043858 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043858 [ RunTime:0.001575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (171422,520371,90850,998365,171329,994288,302988,563893,833823,809419,600699,634753,346759,571331,509316,254490,282265,457715,827994,192646,657029,673607,505084,159095,672563,227237,67817,484980,234034,879510,923008,464204,749315,800840,671345,832281,451304,901774,461753,342494,438668,974707,625859,193523,90070,117359,204341,736699,893733,573078,673454,360475,334809,376150,522351,515437,369825,495209,269129,617390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000899s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043858 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043858 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]