SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028521 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028521 [ RunTime:0.001558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (735542,394993,862522,820506,110708,588126,9565,461044,390461,445468,161806,806733,171092,870752,412337,716348,237704,694597,157602,459007,1048124,254964,817115,111783,37526,935879,1024188,400135,695003,312901,995433,813064,514654,829474,744224,549249,992066,918461,849928,871803,372036,177373,772748,344157,927220,334021,156738,854188,727310,370019,918033,518668,1021996,227848,868664,733773,1036893,49272,500182,663685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]