SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511931 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511931 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15652,944684,49263,493672,348003,642224,727430,366623,276988,363660,673848,622054,289874,741125,760427,41977,527164,1707,385311,877055,823227,614729,175229,205037,743880,820438,391141,858245,94963,201916,45588,821965,90762,483921,169508,394068,990850,480980,678301,350583,482855,385495,386910,863220,732971,366275,103211,456406,22601,386900,892471,421763,38598,1024758,916207,875493,668315,420077,638036,419737) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511931 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511931 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]