SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017602 LIMIT 1 [ RunTime:0.000286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017602 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (925405,271468,297331,353958,472980,383383,601206,827641,676486,174994,875925,50920,1012095,852934,746142,512470,40120,899702,799058,111110,176402,965081,803312,496801,344593,277588,454384,357386,30118,346172,886151,26041,889467,427012,359358,678118,124884,761108,792983,205992,897885,921359,143209,329417,225459,417289,540972,181532,810831,814761,874457,484646,73399,764316,169370,497781,25760,458518,1017030,349733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017602 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017602 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000408s ]