SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584481 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584481 [ RunTime:0.001844s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027827,1025816,715174,745273,931609,624596,251890,405186,209006,307872,235008,985709,713615,710904,942196,826586,279116,917299,713801,317451,785520,1035729,971535,787536,785577,744909,950466,938680,199885,262678,552344,953468,461449,126049,115870,839535,963281,641481,872229,570257,312525,528734,1001060,436595,852676,806255,1407,590395,743514,1020224,933764,519575,877673,864946,210969,790623,442182,377809,327457,1017111) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]