SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449514 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449514 [ RunTime:0.002167s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043972,20702,103576,323224,376047,442391,34170,518461,949377,813641,390451,656542,325742,162619,784458,887863,579973,867886,916951,955922,760841,640772,865586,93576,823147,206495,569716,265201,448664,1045692,439233,30306,589520,549360,511623,226758,949712,756013,522751,631061,803678,44013,867949,260587,196075,279649,493952,110535,616489,675147,811512,628063,434839,466146,65837,373805,708458,967460,1027054,940729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000576s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]