SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400336 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400336 [ RunTime:0.001938s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (268448,53744,91551,859011,388253,530119,1039581,1018386,355255,136697,282176,212162,647506,586852,645387,873918,258812,675135,24661,652601,875678,922831,975134,977043,948894,560949,29323,311598,963464,120427,817373,759080,416342,598706,986657,8679,559124,764513,748650,488409,147406,912087,749437,393834,785564,729892,453908,1002615,496522,384169,13991,617491,824539,665093,12643,985458,878557,599871,336411,180229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400336 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000682s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400336 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]