SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 717481 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 717481 [ RunTime:0.001798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (136237,144508,791697,648376,680384,610010,242346,42345,114455,951077,103043,997361,1041884,651856,708826,227129,243547,68471,569885,283570,1027416,195845,415085,273542,718521,594495,152899,54674,36558,290860,685664,628758,181439,526154,116153,797163,98184,802462,1016417,447529,705938,518962,838915,414309,289910,711384,396872,189243,717463,701384,195699,227409,16202,691883,1023830,1004375,255871,704500,335705,204900) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 717481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 717481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]