SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400126 LIMIT 1 [ RunTime:0.000466s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400126 [ RunTime:0.001792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545239,276477,18449,829315,589586,743826,44966,272529,115824,1003993,294868,10574,976993,796871,936608,161115,385737,276357,417474,828614,346255,428218,690125,325702,441387,605776,82394,1015405,456159,908189,146100,73874,973867,392254,350628,300005,577425,895854,415585,756465,483078,73385,72696,763519,462492,306468,876125,457192,934152,688773,78828,701862,128462,396494,829940,962469,773730,45206,409428,247298) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400126 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400126 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]