SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809543 LIMIT 1 [ RunTime:0.000494s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809543 [ RunTime:0.001792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (948267,1041311,41159,809362,557837,985012,334781,798401,671738,255360,612582,467613,412274,586572,366702,969045,603133,808775,192013,440295,49245,399580,371376,146866,22480,448441,505312,419448,904476,131090,56275,849468,18363,277870,114502,63620,616427,799016,248695,817863,705262,1023728,164060,329557,809141,23920,957650,1028188,923159,625298,955029,492060,899094,158181,392701,922445,176213,318282,401108,908643) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]