SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535450 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535450 [ RunTime:0.002654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (461891,597106,333557,691888,683098,510056,283764,473457,973892,303499,324009,296497,942928,369968,500988,9877,101620,973842,116839,321904,745993,825344,366545,540368,840686,1009315,1018314,726332,930133,731235,36239,836211,979661,58702,807812,716145,868475,212565,960060,559180,859119,244317,752486,56774,9350,571662,444927,278224,463085,1012311,310080,999898,249685,245226,273843,813282,251204,306561,903767,574111) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000882s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]