SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001405s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541828 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541828 [ RunTime:0.001513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (783137,207355,899406,662325,427088,993284,15011,466217,990995,972488,617070,1022290,235293,243850,267154,152675,626579,820959,431203,188732,998378,238213,132867,375720,856576,72353,967430,935951,257240,704973,747964,184432,414565,1007508,934236,191572,197942,911575,333616,557768,262197,109380,317491,414348,59111,126915,648431,926973,554364,744217,972502,1028310,296847,716514,875350,71002,698400,344838,416886,690874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]