SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 553510 LIMIT 1 [ RunTime:0.001313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 553510 [ RunTime:0.001542s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (53051,533651,420621,163303,778410,67741,685512,903122,986123,341508,977146,745127,799847,100506,138584,137164,386788,398096,462690,452883,119804,695508,192366,187284,701032,467447,498738,745274,547405,940203,678184,271782,806246,746474,117267,255375,744148,228515,275657,153082,97898,127521,770618,741517,769826,108413,413240,650273,942598,138654,178203,309068,580721,959468,174242,47931,961823,644050,703493,689378) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 553510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 553510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000854s ]