SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480820 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480820 [ RunTime:0.001808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012174,773413,724204,908122,63466,862568,195474,808909,121381,481713,936147,1036348,362927,240159,275845,494280,637976,953640,88214,459338,262413,1019991,71770,588715,465570,957481,841129,652966,377863,344006,938683,224508,838471,768637,928719,729180,198721,783967,491693,24871,730160,140079,857943,148673,146347,575798,319234,977495,306721,786225,445903,240589,318652,525824,1045468,298689,585304,1025139,609599,416023) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000831s ]